<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.24.xsd"
        objectQuotingStrategy="QUOTE_ONLY_RESERVED_WORDS">

    <changeSet id="create-table-match_stages-1" author="alisitsin (generated)">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="match_stages"/>
            </not>
        </preConditions>
        <createTable tableName="match_stages">
            <column name="match_stage_id" type="BIGINT">
                <constraints nullable="false" primaryKey="true" primaryKeyName="pk_match_stages"/>
            </column>
            <column name="name" type="VARCHAR(255)"/>
            <column name="code" type="VARCHAR(255)"/>
        </createTable>
        <comment>create table match_stages</comment>
    </changeSet>

    <changeSet id="add-match_stage_id_seq-1" author="alisitsin (generated)">
        <preConditions onFail="MARK_RAN">
            <not>
                <sequenceExists sequenceName="match_stage_id_seq"/>
            </not>
        </preConditions>
        <createSequence incrementBy="1" sequenceName="match_stage_id_seq" startValue="1000" minValue="1000"/>
        <comment>add match_stage_id_seq</comment>
    </changeSet>
</databaseChangeLog>